2014-06-13 - 13251 - Enhancement - Create odbcad32 connection #CrystalReportsSupport

ENHANCEMENT

13251 - Create odbcad32 connection

Requirement Summary

---

Create odbcad32 connection so that excel 2010 format can be used as a input source to crystal reports and UPC can be compared from Menlo material master.

Admin Info

---

Purpose	Create odbcad32 connection
Requested By	Saravanan Lakshmanan
Spec Created By	Praveen Guntuka
Spec Created Date	06-13-2014
Spec QA by	Uday Kumar P
Objects	UPC Report
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

Need to create ODBC 32 bit connection to use Microsoft Excel Workbook(.xlsx) as datasource for UPC report.

Solution Summary

---

1. Need to change the datatype for UPC numbers in sheet.
2. Need to save the CSV file as MS Workbook.
3. Need to create ODBC 32 bit driver.
4. Need to create report using ODBC driver.

Solution Details

---

1. Need to change the datatype to Number for UPC values in the Sheet.
2. Need to save the CSV file to MS Workbook(.xlsx) format.
3. Need to create ODBC 32 bit driver for Excel sheet.
4. Need to use the ODBC 32 bit driver in the report to access MS Workbook.
5. Need to link the Sheet UPC numbers to EAN11 field in MEAN table.

Issues

---

Report changes moved by NEC.